🕷️️ Job Radar • SCRAPING

freelancer.com 🟡 2026-05-16

🔹 Excel Cleanup: 200k Contacts
👤 Client: 🇮🇳 Sonipat, India Member since 2023-05-27
💰 Price: $16 Average bid
🚩 Problem: Remove duplicates and standardize phone numbers in a large Excel file.
📦 Existing: Not specified

Specifications:

[Target] Clean and standardize 200,000 contact records from an .xlsx file.
[Method] Use a combination of formulas, Power Query, and VBA to ensure uniform formatting and removal of duplicates.
[UI/UX] Ensure the final Excel workbook is clean with no broken formulas or stray characters.
[Stack] Microsoft Excel, Power Query, VBA
[Security] No specific security requirements mentioned.
[Format] Final output should be a single sheet in an .xlsx file with standardized phone numbers and no duplicates.

Workflow:

Review the existing .xlsx file to understand its structure and any potential issues.
Identify and remove duplicate entries based on phone numbers, ensuring consistent formatting (add or strip +91 as needed).
Apply uniform formatting rules for all phone numbers across the dataset.
Run initial checks to ensure no broken formulas, blank rows, or stray characters remain.
Provide sample outputs for review before processing the full 200k records.